package com.akk.module.avs.entity;

import org.springframework.stereotype.Component;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@Component
public class AvsYbLoanExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public AvsYbLoanExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andLoanIdIsNull() {
            addCriterion("loan_id is null");
            return (Criteria) this;
        }

        public Criteria andLoanIdIsNotNull() {
            addCriterion("loan_id is not null");
            return (Criteria) this;
        }

        public Criteria andLoanIdEqualTo(Long value) {
            addCriterion("loan_id =", value, "loanId");
            return (Criteria) this;
        }

        public Criteria andLoanIdNotEqualTo(Long value) {
            addCriterion("loan_id <>", value, "loanId");
            return (Criteria) this;
        }

        public Criteria andLoanIdGreaterThan(Long value) {
            addCriterion("loan_id >", value, "loanId");
            return (Criteria) this;
        }

        public Criteria andLoanIdGreaterThanOrEqualTo(Long value) {
            addCriterion("loan_id >=", value, "loanId");
            return (Criteria) this;
        }

        public Criteria andLoanIdLessThan(Long value) {
            addCriterion("loan_id <", value, "loanId");
            return (Criteria) this;
        }

        public Criteria andLoanIdLessThanOrEqualTo(Long value) {
            addCriterion("loan_id <=", value, "loanId");
            return (Criteria) this;
        }

        public Criteria andLoanIdIn(List<Long> values) {
            addCriterion("loan_id in", values, "loanId");
            return (Criteria) this;
        }

        public Criteria andLoanIdNotIn(List<Long> values) {
            addCriterion("loan_id not in", values, "loanId");
            return (Criteria) this;
        }

        public Criteria andLoanIdBetween(Long value1, Long value2) {
            addCriterion("loan_id between", value1, value2, "loanId");
            return (Criteria) this;
        }

        public Criteria andLoanIdNotBetween(Long value1, Long value2) {
            addCriterion("loan_id not between", value1, value2, "loanId");
            return (Criteria) this;
        }

        public Criteria andLoanNameIsNull() {
            addCriterion("loan_name is null");
            return (Criteria) this;
        }

        public Criteria andLoanNameIsNotNull() {
            addCriterion("loan_name is not null");
            return (Criteria) this;
        }

        public Criteria andLoanNameEqualTo(String value) {
            addCriterion("loan_name =", value, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanNameNotEqualTo(String value) {
            addCriterion("loan_name <>", value, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanNameGreaterThan(String value) {
            addCriterion("loan_name >", value, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanNameGreaterThanOrEqualTo(String value) {
            addCriterion("loan_name >=", value, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanNameLessThan(String value) {
            addCriterion("loan_name <", value, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanNameLessThanOrEqualTo(String value) {
            addCriterion("loan_name <=", value, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanNameLike(String value) {
            addCriterion("loan_name like", value, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanNameNotLike(String value) {
            addCriterion("loan_name not like", value, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanNameIn(List<String> values) {
            addCriterion("loan_name in", values, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanNameNotIn(List<String> values) {
            addCriterion("loan_name not in", values, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanNameBetween(String value1, String value2) {
            addCriterion("loan_name between", value1, value2, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanNameNotBetween(String value1, String value2) {
            addCriterion("loan_name not between", value1, value2, "loanName");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdIsNull() {
            addCriterion("loan_type_id is null");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdIsNotNull() {
            addCriterion("loan_type_id is not null");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdEqualTo(Long value) {
            addCriterion("loan_type_id =", value, "loanTypeId");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdNotEqualTo(Long value) {
            addCriterion("loan_type_id <>", value, "loanTypeId");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdGreaterThan(Long value) {
            addCriterion("loan_type_id >", value, "loanTypeId");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdGreaterThanOrEqualTo(Long value) {
            addCriterion("loan_type_id >=", value, "loanTypeId");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdLessThan(Long value) {
            addCriterion("loan_type_id <", value, "loanTypeId");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdLessThanOrEqualTo(Long value) {
            addCriterion("loan_type_id <=", value, "loanTypeId");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdIn(List<Long> values) {
            addCriterion("loan_type_id in", values, "loanTypeId");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdNotIn(List<Long> values) {
            addCriterion("loan_type_id not in", values, "loanTypeId");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdBetween(Long value1, Long value2) {
            addCriterion("loan_type_id between", value1, value2, "loanTypeId");
            return (Criteria) this;
        }

        public Criteria andLoanTypeIdNotBetween(Long value1, Long value2) {
            addCriterion("loan_type_id not between", value1, value2, "loanTypeId");
            return (Criteria) this;
        }

        public Criteria andLoanStatusIsNull() {
            addCriterion("loan_status is null");
            return (Criteria) this;
        }

        public Criteria andLoanStatusIsNotNull() {
            addCriterion("loan_status is not null");
            return (Criteria) this;
        }

        public Criteria andLoanStatusEqualTo(Integer value) {
            addCriterion("loan_status =", value, "loanStatus");
            return (Criteria) this;
        }

        public Criteria andLoanStatusNotEqualTo(Integer value) {
            addCriterion("loan_status <>", value, "loanStatus");
            return (Criteria) this;
        }

        public Criteria andLoanStatusGreaterThan(Integer value) {
            addCriterion("loan_status >", value, "loanStatus");
            return (Criteria) this;
        }

        public Criteria andLoanStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("loan_status >=", value, "loanStatus");
            return (Criteria) this;
        }

        public Criteria andLoanStatusLessThan(Integer value) {
            addCriterion("loan_status <", value, "loanStatus");
            return (Criteria) this;
        }

        public Criteria andLoanStatusLessThanOrEqualTo(Integer value) {
            addCriterion("loan_status <=", value, "loanStatus");
            return (Criteria) this;
        }

        public Criteria andLoanStatusIn(List<Integer> values) {
            addCriterion("loan_status in", values, "loanStatus");
            return (Criteria) this;
        }

        public Criteria andLoanStatusNotIn(List<Integer> values) {
            addCriterion("loan_status not in", values, "loanStatus");
            return (Criteria) this;
        }

        public Criteria andLoanStatusBetween(Integer value1, Integer value2) {
            addCriterion("loan_status between", value1, value2, "loanStatus");
            return (Criteria) this;
        }

        public Criteria andLoanStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("loan_status not between", value1, value2, "loanStatus");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaIsNull() {
            addCriterion("loan_quota is null");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaIsNotNull() {
            addCriterion("loan_quota is not null");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaEqualTo(String value) {
            addCriterion("loan_quota =", value, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaNotEqualTo(String value) {
            addCriterion("loan_quota <>", value, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaGreaterThan(String value) {
            addCriterion("loan_quota >", value, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaGreaterThanOrEqualTo(String value) {
            addCriterion("loan_quota >=", value, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaLessThan(String value) {
            addCriterion("loan_quota <", value, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaLessThanOrEqualTo(String value) {
            addCriterion("loan_quota <=", value, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaLike(String value) {
            addCriterion("loan_quota like", value, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaNotLike(String value) {
            addCriterion("loan_quota not like", value, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaIn(List<String> values) {
            addCriterion("loan_quota in", values, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaNotIn(List<String> values) {
            addCriterion("loan_quota not in", values, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaBetween(String value1, String value2) {
            addCriterion("loan_quota between", value1, value2, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanQuotaNotBetween(String value1, String value2) {
            addCriterion("loan_quota not between", value1, value2, "loanQuota");
            return (Criteria) this;
        }

        public Criteria andLoanRateIsNull() {
            addCriterion("loan_rate is null");
            return (Criteria) this;
        }

        public Criteria andLoanRateIsNotNull() {
            addCriterion("loan_rate is not null");
            return (Criteria) this;
        }

        public Criteria andLoanRateEqualTo(String value) {
            addCriterion("loan_rate =", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateNotEqualTo(String value) {
            addCriterion("loan_rate <>", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateGreaterThan(String value) {
            addCriterion("loan_rate >", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateGreaterThanOrEqualTo(String value) {
            addCriterion("loan_rate >=", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateLessThan(String value) {
            addCriterion("loan_rate <", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateLessThanOrEqualTo(String value) {
            addCriterion("loan_rate <=", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateLike(String value) {
            addCriterion("loan_rate like", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateNotLike(String value) {
            addCriterion("loan_rate not like", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateIn(List<String> values) {
            addCriterion("loan_rate in", values, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateNotIn(List<String> values) {
            addCriterion("loan_rate not in", values, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateBetween(String value1, String value2) {
            addCriterion("loan_rate between", value1, value2, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateNotBetween(String value1, String value2) {
            addCriterion("loan_rate not between", value1, value2, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanTermIsNull() {
            addCriterion("loan_term is null");
            return (Criteria) this;
        }

        public Criteria andLoanTermIsNotNull() {
            addCriterion("loan_term is not null");
            return (Criteria) this;
        }

        public Criteria andLoanTermEqualTo(String value) {
            addCriterion("loan_term =", value, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanTermNotEqualTo(String value) {
            addCriterion("loan_term <>", value, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanTermGreaterThan(String value) {
            addCriterion("loan_term >", value, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanTermGreaterThanOrEqualTo(String value) {
            addCriterion("loan_term >=", value, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanTermLessThan(String value) {
            addCriterion("loan_term <", value, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanTermLessThanOrEqualTo(String value) {
            addCriterion("loan_term <=", value, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanTermLike(String value) {
            addCriterion("loan_term like", value, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanTermNotLike(String value) {
            addCriterion("loan_term not like", value, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanTermIn(List<String> values) {
            addCriterion("loan_term in", values, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanTermNotIn(List<String> values) {
            addCriterion("loan_term not in", values, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanTermBetween(String value1, String value2) {
            addCriterion("loan_term between", value1, value2, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanTermNotBetween(String value1, String value2) {
            addCriterion("loan_term not between", value1, value2, "loanTerm");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentIsNull() {
            addCriterion("loan_payment is null");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentIsNotNull() {
            addCriterion("loan_payment is not null");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentEqualTo(String value) {
            addCriterion("loan_payment =", value, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentNotEqualTo(String value) {
            addCriterion("loan_payment <>", value, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentGreaterThan(String value) {
            addCriterion("loan_payment >", value, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentGreaterThanOrEqualTo(String value) {
            addCriterion("loan_payment >=", value, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentLessThan(String value) {
            addCriterion("loan_payment <", value, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentLessThanOrEqualTo(String value) {
            addCriterion("loan_payment <=", value, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentLike(String value) {
            addCriterion("loan_payment like", value, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentNotLike(String value) {
            addCriterion("loan_payment not like", value, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentIn(List<String> values) {
            addCriterion("loan_payment in", values, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentNotIn(List<String> values) {
            addCriterion("loan_payment not in", values, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentBetween(String value1, String value2) {
            addCriterion("loan_payment between", value1, value2, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanPaymentNotBetween(String value1, String value2) {
            addCriterion("loan_payment not between", value1, value2, "loanPayment");
            return (Criteria) this;
        }

        public Criteria andLoanAdvIsNull() {
            addCriterion("loan_adv is null");
            return (Criteria) this;
        }

        public Criteria andLoanAdvIsNotNull() {
            addCriterion("loan_adv is not null");
            return (Criteria) this;
        }

        public Criteria andLoanAdvEqualTo(String value) {
            addCriterion("loan_adv =", value, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanAdvNotEqualTo(String value) {
            addCriterion("loan_adv <>", value, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanAdvGreaterThan(String value) {
            addCriterion("loan_adv >", value, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanAdvGreaterThanOrEqualTo(String value) {
            addCriterion("loan_adv >=", value, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanAdvLessThan(String value) {
            addCriterion("loan_adv <", value, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanAdvLessThanOrEqualTo(String value) {
            addCriterion("loan_adv <=", value, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanAdvLike(String value) {
            addCriterion("loan_adv like", value, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanAdvNotLike(String value) {
            addCriterion("loan_adv not like", value, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanAdvIn(List<String> values) {
            addCriterion("loan_adv in", values, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanAdvNotIn(List<String> values) {
            addCriterion("loan_adv not in", values, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanAdvBetween(String value1, String value2) {
            addCriterion("loan_adv between", value1, value2, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanAdvNotBetween(String value1, String value2) {
            addCriterion("loan_adv not between", value1, value2, "loanAdv");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConIsNull() {
            addCriterion("loan_apply_con is null");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConIsNotNull() {
            addCriterion("loan_apply_con is not null");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConEqualTo(String value) {
            addCriterion("loan_apply_con =", value, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConNotEqualTo(String value) {
            addCriterion("loan_apply_con <>", value, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConGreaterThan(String value) {
            addCriterion("loan_apply_con >", value, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConGreaterThanOrEqualTo(String value) {
            addCriterion("loan_apply_con >=", value, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConLessThan(String value) {
            addCriterion("loan_apply_con <", value, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConLessThanOrEqualTo(String value) {
            addCriterion("loan_apply_con <=", value, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConLike(String value) {
            addCriterion("loan_apply_con like", value, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConNotLike(String value) {
            addCriterion("loan_apply_con not like", value, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConIn(List<String> values) {
            addCriterion("loan_apply_con in", values, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConNotIn(List<String> values) {
            addCriterion("loan_apply_con not in", values, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConBetween(String value1, String value2) {
            addCriterion("loan_apply_con between", value1, value2, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanApplyConNotBetween(String value1, String value2) {
            addCriterion("loan_apply_con not between", value1, value2, "loanApplyCon");
            return (Criteria) this;
        }

        public Criteria andLoanMortIsNull() {
            addCriterion("loan_mort is null");
            return (Criteria) this;
        }

        public Criteria andLoanMortIsNotNull() {
            addCriterion("loan_mort is not null");
            return (Criteria) this;
        }

        public Criteria andLoanMortEqualTo(String value) {
            addCriterion("loan_mort =", value, "loanMort");
            return (Criteria) this;
        }

        public Criteria andLoanMortNotEqualTo(String value) {
            addCriterion("loan_mort <>", value, "loanMort");
            return (Criteria) this;
        }

        public Criteria andLoanMortGreaterThan(String value) {
            addCriterion("loan_mort >", value, "loanMort");
            return (Criteria) this;
        }

        public Criteria andLoanMortGreaterThanOrEqualTo(String value) {
            addCriterion("loan_mort >=", value, "loanMort");
            return (Criteria) this;
        }

        public Criteria andLoanMortLessThan(String value) {
            addCriterion("loan_mort <", value, "loanMort");
            return (Criteria) this;
        }

        public Criteria andLoanMortLessThanOrEqualTo(String value) {
            addCriterion("loan_mort <=", value, "loanMort");
            return (Criteria) this;
        }

        public Criteria andLoanMortLike(String value) {
            addCriterion("loan_mort like", value, "loanMort");
            return (Criteria) this;
        }

        public Criteria andLoanMortNotLike(String value) {
            addCriterion("loan_mort not like", value, "loanMort");
            return (Criteria) this;
        }

        public Criteria andLoanMortIn(List<String> values) {
            addCriterion("loan_mort in", values, "loanMort");
            return (Criteria) this;
        }

        public Criteria andLoanMortNotIn(List<String> values) {
            addCriterion("loan_mort not in", values, "loanMort");
            return (Criteria) this;
        }

        public Criteria andLoanMortBetween(String value1, String value2) {
            addCriterion("loan_mort between", value1, value2, "loanMort");
            return (Criteria) this;
        }

        public Criteria andLoanMortNotBetween(String value1, String value2) {
            addCriterion("loan_mort not between", value1, value2, "loanMort");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_date is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_date is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("create_date =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("create_date <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("create_date >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("create_date >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("create_date <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("create_date <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("create_date in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("create_date not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("create_date between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("create_date not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andAppIdIsNull() {
            addCriterion("app_id is null");
            return (Criteria) this;
        }

        public Criteria andAppIdIsNotNull() {
            addCriterion("app_id is not null");
            return (Criteria) this;
        }

        public Criteria andAppIdEqualTo(String value) {
            addCriterion("app_id =", value, "appId");
            return (Criteria) this;
        }

        public Criteria andAppIdNotEqualTo(String value) {
            addCriterion("app_id <>", value, "appId");
            return (Criteria) this;
        }

        public Criteria andAppIdGreaterThan(String value) {
            addCriterion("app_id >", value, "appId");
            return (Criteria) this;
        }

        public Criteria andAppIdGreaterThanOrEqualTo(String value) {
            addCriterion("app_id >=", value, "appId");
            return (Criteria) this;
        }

        public Criteria andAppIdLessThan(String value) {
            addCriterion("app_id <", value, "appId");
            return (Criteria) this;
        }

        public Criteria andAppIdLessThanOrEqualTo(String value) {
            addCriterion("app_id <=", value, "appId");
            return (Criteria) this;
        }

        public Criteria andAppIdLike(String value) {
            addCriterion("app_id like", value, "appId");
            return (Criteria) this;
        }

        public Criteria andAppIdNotLike(String value) {
            addCriterion("app_id not like", value, "appId");
            return (Criteria) this;
        }

        public Criteria andAppIdIn(List<String> values) {
            addCriterion("app_id in", values, "appId");
            return (Criteria) this;
        }

        public Criteria andAppIdNotIn(List<String> values) {
            addCriterion("app_id not in", values, "appId");
            return (Criteria) this;
        }

        public Criteria andAppIdBetween(String value1, String value2) {
            addCriterion("app_id between", value1, value2, "appId");
            return (Criteria) this;
        }

        public Criteria andAppIdNotBetween(String value1, String value2) {
            addCriterion("app_id not between", value1, value2, "appId");
            return (Criteria) this;
        }

        public Criteria andLoanMaterIsNull() {
            addCriterion("loan_mater is null");
            return (Criteria) this;
        }

        public Criteria andLoanMaterIsNotNull() {
            addCriterion("loan_mater is not null");
            return (Criteria) this;
        }

        public Criteria andLoanMaterEqualTo(String value) {
            addCriterion("loan_mater =", value, "loanMater");
            return (Criteria) this;
        }

        public Criteria andLoanMaterNotEqualTo(String value) {
            addCriterion("loan_mater <>", value, "loanMater");
            return (Criteria) this;
        }

        public Criteria andLoanMaterGreaterThan(String value) {
            addCriterion("loan_mater >", value, "loanMater");
            return (Criteria) this;
        }

        public Criteria andLoanMaterGreaterThanOrEqualTo(String value) {
            addCriterion("loan_mater >=", value, "loanMater");
            return (Criteria) this;
        }

        public Criteria andLoanMaterLessThan(String value) {
            addCriterion("loan_mater <", value, "loanMater");
            return (Criteria) this;
        }

        public Criteria andLoanMaterLessThanOrEqualTo(String value) {
            addCriterion("loan_mater <=", value, "loanMater");
            return (Criteria) this;
        }

        public Criteria andLoanMaterLike(String value) {
            addCriterion("loan_mater like", value, "loanMater");
            return (Criteria) this;
        }

        public Criteria andLoanMaterNotLike(String value) {
            addCriterion("loan_mater not like", value, "loanMater");
            return (Criteria) this;
        }

        public Criteria andLoanMaterIn(List<String> values) {
            addCriterion("loan_mater in", values, "loanMater");
            return (Criteria) this;
        }

        public Criteria andLoanMaterNotIn(List<String> values) {
            addCriterion("loan_mater not in", values, "loanMater");
            return (Criteria) this;
        }

        public Criteria andLoanMaterBetween(String value1, String value2) {
            addCriterion("loan_mater between", value1, value2, "loanMater");
            return (Criteria) this;
        }

        public Criteria andLoanMaterNotBetween(String value1, String value2) {
            addCriterion("loan_mater not between", value1, value2, "loanMater");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}